﻿-- Creating foreign key on [HN] in table 'Appointments'
-- Creating foreign key on [HN] in table 'Appointments'
-- Creating foreign key on [HN] in table 'Appointments'
-- Creating foreign key on [HN] in table 'Appointments'
-- Creating foreign key on [HN] in table 'Appointments'
ALTER TABLE [dbo].[Appointments]
ADD CONSTRAINT [FK_AppointedPatientAppointment]
    FOREIGN KEY ([HN])
    REFERENCES [dbo].[AppointedPatients]
        ([HN])
    ON DELETE NO ACTION ON UPDATE NO ACTION;














